USE [AESDB]
GO

/****** Object:  Table [dbo].[UserRegistration]    Script Date: 03/05/2013 20:41:31 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[UserRegistration](
	[UserID] [int] IDENTITY(1,1) NOT NULL,
	[UserName] [nvarchar](50) NOT NULL,
	[Password] [nvarchar](50) NOT NULL,
	[FirstName] [nvarchar](50) NOT NULL,
	[MI] [nvarchar](2) NOT NULL,
	[LastName] [nvarchar](50) NOT NULL,
	[Address] [nvarchar](max) NOT NULL,
	[PhoneNumber] [nvarchar](50) NOT NULL,
	[Status] [bit] NULL
) ON [PRIMARY]

GO

ALTER TABLE [dbo].[UserRegistration] ADD  CONSTRAINT [DF_UserRegistration_Status]  DEFAULT ((1)) FOR [Status]
GO

